{"statement":"SELECT 1 AS mock_232, sum(tbl_mock_236.mock_006) AS mock_006, sum(tbl_mock_236.mock_076) AS mock_076, sum(tbl_mock_236.mock_077) AS mock_077, sum(tbl_mock_236.mock_005) AS mock_005, sum(tbl_mock_236.mock_089) AS mock_089, sum(tbl_mock_236.mock_233) AS mock_233, sum(tbl_mock_236.mock_234) AS mock_234, sum(tbl_mock_236.mock_235) AS mock_235\nFROM (SELECT tbl_mock_236.mock_006, tbl_mock_236.mock_076, tbl_mock_236.mock_077, tbl_mock_236.mock_005, tbl_mock_236.mock_089, tbl_mock_236.mock_233, tbl_mock_236.mock_234, tbl_mock_236.mock_235, unnest AS mock_205\nFROM (SELECT coalesce(tbl_mock_261.mock_205, \u0027-1\u0027) AS mock_205, sum(((coalesce(tbl_mock_253.mock_006, 0)) * tbl_mock_263.mock_164) / tbl_mock_266.mock_164) AS mock_006, sum(((coalesce(tbl_mock_253.mock_076, 0)) * tbl_mock_263.mock_164) / tbl_mock_266.mock_164) AS mock_076, sum(((coalesce(tbl_mock_253.mock_077, 0)) * tbl_mock_263.mock_164) / tbl_mock_266.mock_164) AS mock_077, sum(((coalesce(tbl_mock_253.mock_005, 0)) * tbl_mock_263.mock_164) / tbl_mock_266.mock_164) AS mock_005, sum(((coalesce(tbl_mock_253.mock_089, 0)) * tbl_mock_263.mock_164) / tbl_mock_266.mock_164) AS mock_089, 0 AS mock_233, sum((((((((coalesce(tbl_mock_253.mock_237, 0)) + (coalesce(tbl_mock_253.mock_136, 0))) + (coalesce(tbl_mock_253.mock_059, 0))) + (coalesce(tbl_mock_253.mock_026, 0))) + (coalesce(tbl_mock_253.mock_238, 0))) + (coalesce(tbl_mock_253.mock_239, 0))) * (coalesce(tbl_mock_263.mock_164, 1))) / (coalesce(tbl_mock_266.mock_164, 1))) AS mock_235, sum(((((((((((((((((((((coalesce(tbl_mock_253.mock_237, 0)) * (coalesce(tbl_mock_263.mock_164, 1))) + ((coalesce(tbl_mock_253.mock_136, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_059, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_026, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_238, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_239, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_240, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_241, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_242, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_243, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_046, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_244, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_245, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_246, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_247, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_248, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) + ((coalesce(tbl_mock_253.mock_004, 0)) * (coalesce(tbl_mock_263.mock_164, 1)))) - ((coalesce(tbl_mock_261.mock_008 * tbl_mock_253.mock_249, 0)) * (coalesce(tbl_mock_264.mock_164, 1)))) - ((coalesce(tbl_mock_261.mock_009 * tbl_mock_253.mock_250, 0)) * (coalesce(tbl_mock_265.mock_164, 1)))) / (coalesce(tbl_mock_266.mock_164, 1))) AS mock_234\nFROM (SELECT tbl_mock_253.mock_049 AS mock_251, tbl_mock_260.mock_176, tbl_mock_260.mock_171, tbl_mock_253.mock_073, (((coalesce(tbl_mock_253.mock_076, 0)) + (coalesce(tbl_mock_253.mock_077, 0))) + (coalesce(tbl_mock_253.mock_005, 0))) + (coalesce(tbl_mock_253.mock_006, 0)) AS mock_244, NULL AS mock_089, (coalesce(tbl_mock_253.mock_005, 0)) + (coalesce(tbl_mock_253.mock_006, 0)) AS mock_252, coalesce(tbl_mock_253.mock_076, 0) AS mock_076, coalesce(tbl_mock_253.mock_077, 0) AS mock_077, coalesce(tbl_mock_253.mock_005, 0) AS mock_005, coalesce(tbl_mock_253.mock_006, 0) AS mock_006, (((((((((coalesce(tbl_mock_253.mock_041, 0)) + (coalesce(tbl_mock_253.mock_052, 0))) + (coalesce(tbl_mock_253.mock_064, 0))) + (coalesce(tbl_mock_253.mock_116, 0))) + (coalesce(tbl_mock_253.mock_044, 0))) + (coalesce(tbl_mock_253.mock_056, 0))) + (coalesce(tbl_mock_253.mock_068, 0))) + (coalesce(tbl_mock_253.mock_033, 0))) + (coalesce(tbl_mock_253.mock_003, 0))) + (coalesce(tbl_mock_253.mock_021, 0)) AS mock_237, coalesce(tbl_mock_253.mock_136, 0) AS mock_136, (coalesce(tbl_mock_253.mock_059, 0)) + (coalesce(tbl_mock_253.mock_254, 0)) AS mock_059, (coalesce(tbl_mock_253.mock_026, 0)) + (coalesce(tbl_mock_253.mock_100, 0)) AS mock_026, coalesce(tbl_mock_253.mock_084, 0) AS mock_238, ((((((((coalesce(tbl_mock_253.mock_101, 0)) + (coalesce(tbl_mock_253.mock_081, 0))) + (coalesce(tbl_mock_253.mock_124, 0))) + (coalesce(tbl_mock_253.mock_114, 0))) + (coalesce(tbl_mock_253.mock_123, 0))) + (coalesce(tbl_mock_253.mock_086, 0))) + (coalesce(tbl_mock_253.mock_119, 0))) + (coalesce(tbl_mock_253.mock_102, 0))) + (coalesce(tbl_mock_253.mock_088, 0)) AS mock_239, (((((((((((coalesce(tbl_mock_253.mock_040, 0)) + (coalesce(tbl_mock_253.mock_050, 0))) + (coalesce(tbl_mock_253.mock_062, 0))) + (coalesce(tbl_mock_253.mock_043, 0))) + (coalesce(tbl_mock_253.mock_054, 0))) + (coalesce(tbl_mock_253.mock_066, 0))) + (coalesce(tbl_mock_253.mock_135, 0))) + (coalesce(tbl_mock_253.mock_032, 0))) + (coalesce(tbl_mock_253.mock_011, 0))) + (coalesce(tbl_mock_253.mock_022, 0))) + (coalesce(tbl_mock_253.mock_058, 0))) + (coalesce(tbl_mock_253.mock_255, 0)) AS mock_240, ((((((((coalesce(tbl_mock_253.mock_074, 0)) + (coalesce(tbl_mock_253.mock_031, 0))) + (coalesce(tbl_mock_253.mock_106, 0))) + (coalesce(tbl_mock_253.mock_060, 0))) + (coalesce(tbl_mock_253.mock_045, 0))) + (coalesce(tbl_mock_253.mock_121, 0))) + (coalesce(tbl_mock_253.mock_048, 0))) + (coalesce(tbl_mock_253.mock_138, 0))) + (coalesce(tbl_mock_253.mock_256, 0)) AS mock_241, (coalesce(tbl_mock_253.mock_071, 0)) + (coalesce(tbl_mock_253.mock_029, 0)) AS mock_242, ((coalesce(tbl_mock_253.mock_042, 0)) + (coalesce(tbl_mock_253.mock_038, 0))) + (coalesce(tbl_mock_253.mock_117, 0)) AS mock_243, (coalesce(tbl_mock_253.mock_046, 0)) + (coalesce(tbl_mock_253.mock_257, 0)) AS mock_046, ((((coalesce(tbl_mock_253.mock_128, 0)) + (coalesce(tbl_mock_253.mock_110, 0))) + (coalesce(tbl_mock_253.mock_090, 0))) + (coalesce(tbl_mock_253.mock_092, 0))) + (coalesce(tbl_mock_253.mock_134, 0)) AS mock_245, (((((((((((((((((((coalesce(tbl_mock_253.mock_030, 0)) + (coalesce(tbl_mock_253.mock_105, 0))) + (coalesce(tbl_mock_253.mock_037, 0))) + (coalesce(tbl_mock_253.mock_112, 0))) + (coalesce(tbl_mock_253.mock_127, 0))) + (coalesce(tbl_mock_253.mock_095, 0))) + (coalesce(tbl_mock_253.mock_104, 0))) + (coalesce(tbl_mock_253.mock_098, 0))) + (coalesce(tbl_mock_253.mock_109, 0))) + (coalesce(tbl_mock_253.mock_120, 0))) + (coalesce(tbl_mock_253.mock_082, 0))) + (coalesce(tbl_mock_253.mock_129, 0))) + (coalesce(tbl_mock_253.mock_094, 0))) + (coalesce(tbl_mock_253.mock_025, 0))) + (coalesce(tbl_mock_253.mock_097, 0))) + (coalesce(tbl_mock_253.mock_103, 0))) + (coalesce(tbl_mock_253.mock_080, 0))) + (coalesce(tbl_mock_253.mock_096, 0))) + (coalesce(tbl_mock_253.mock_108, 0))) + (coalesce(tbl_mock_253.mock_115, 0)) AS mock_246, coalesce(tbl_mock_253.mock_099, 0) AS mock_247, (((((coalesce(tbl_mock_253.mock_137, 0)) + (coalesce(tbl_mock_253.mock_126, 0))) + (coalesce(tbl_mock_253.mock_083, 0))) + (coalesce(tbl_mock_253.mock_111, 0))) + (coalesce(tbl_mock_253.mock_113, 0))) + (coalesce(tbl_mock_253.mock_118, 0)) AS mock_248, (coalesce(tbl_mock_253.mock_004, 0)) + (coalesce(tbl_mock_253.mock_075, 0)) AS mock_004, (((((coalesce(tbl_mock_253.mock_057, 0)) + (coalesce(tbl_mock_253.mock_053, 0))) + (coalesce(tbl_mock_253.mock_069, 0))) + (coalesce(tbl_mock_253.mock_065, 0))) + (coalesce(tbl_mock_253.mock_039, 0))) - (coalesce(tbl_mock_253.mock_027, 0)) AS mock_249, (((((coalesce(tbl_mock_253.mock_057, 0)) + (coalesce(tbl_mock_253.mock_053, 0))) + (coalesce(tbl_mock_253.mock_069, 0))) + (coalesce(tbl_mock_253.mock_065, 0))) + (coalesce(tbl_mock_253.mock_039, 0))) - (coalesce(tbl_mock_253.mock_027, 0)) AS mock_250\nFROM (SELECT tbl_mock_236.*, get_json_double(tbl_mock_236.mock_002, \u0027$.shared_other_transaction_fees\u0027) AS mock_257, get_json_double(tbl_mock_236.mock_002, \u0027$.shared_shipping_label_refunds\u0027) AS mock_256, get_json_double(tbl_mock_236.mock_002, \u0027$.shared_promotional_rebates\u0027) AS mock_254, get_json_double(tbl_mock_236.mock_002, \u0027$.shared_promotional_rebate_refunds\u0027) AS mock_255\nFROM (SELECT *, row_number() OVER (PARTITION BY tbl_mock_253.mock_012, tbl_mock_253.mock_072, tbl_mock_253.mock_023, tbl_mock_253.mock_073, tbl_mock_253.mock_049 ORDER BY tbl_mock_253.id DESC ) AS mock_258\nFROM db_mock_000.tbl_mock_001 AS tbl_mock_253\nWHERE ((tbl_mock_253.mock_012 \u003d 901117781768839168) AND (tbl_mock_253.mock_049 \u003e\u003d \u00272022-08-01\u0027)) AND (tbl_mock_253.mock_049 \u003c\u003d \u00272022-08-31\u0027)) tbl_mock_236\nWHERE tbl_mock_236.mock_258 \u003d 1) tbl_mock_253 INNER JOIN db_mock_000.tbl_mock_148 AS tbl_mock_260 ON ((tbl_mock_253.mock_072 \u003d tbl_mock_260.mock_072) AND (tbl_mock_253.mock_023 \u003d tbl_mock_260.mock_149)) AND (tbl_mock_253.mock_012 \u003d tbl_mock_260.mock_012)\nWHERE tbl_mock_260.mock_176 \u003d 1) tbl_mock_253 INNER JOIN (SELECT tbl_mock_253.mock_176, tbl_mock_253.mock_171, tbl_mock_253.mock_007, tbl_mock_253.mock_073, tbl_mock_253.mock_202, tbl_mock_253.mock_198, tbl_mock_253.mock_008, if((length(tbl_mock_253.mock_182)) \u003e 0, tbl_mock_253.mock_182, \u0027CNY\u0027) AS mock_182, tbl_mock_253.mock_009, if((length(tbl_mock_253.mock_010)) \u003e 0, tbl_mock_253.mock_010, \u0027CNY\u0027) AS mock_010, tbl_mock_262.mock_072, tbl_mock_262.mock_149 AS mock_023, tbl_mock_262.mock_151, tbl_mock_262.mock_152, tbl_mock_262.mock_160, tbl_mock_253.mock_012, tbl_mock_253.mock_205\nFROM db_mock_000.tbl_mock_177 AS tbl_mock_253 INNER JOIN (SELECT *\nFROM db_mock_000.tbl_mock_148 AS tbl_mock_253\nWHERE tbl_mock_253.mock_176 \u003d 1) tbl_mock_262 ON (tbl_mock_253.mock_176 \u003d tbl_mock_262.mock_176) AND (tbl_mock_253.mock_171 \u003d tbl_mock_262.mock_171)\nWHERE ((tbl_mock_253.mock_176 \u003d 1) AND (tbl_mock_253.mock_012 \u003d 901117781768839168)) AND (tbl_mock_253.mock_189 !\u003d 1)) tbl_mock_261 ON ((tbl_mock_261.mock_176 \u003d tbl_mock_253.mock_176) AND (tbl_mock_261.mock_171 \u003d tbl_mock_253.mock_171)) AND (tbl_mock_261.mock_073 \u003d tbl_mock_253.mock_073) LEFT OUTER JOIN (SELECT tbl_mock_221.mock_176, tbl_mock_221.mock_149, tbl_mock_221.mock_223, tbl_mock_221.mock_164, tbl_mock_221.mock_222\nFROM db_mock_000.tbl_mock_221\nWHERE (tbl_mock_221.mock_176 \u003d 1) AND (tbl_mock_221.mock_222 BETWEEN (substring(\u00272022-08-01\u0027, 1, 7)) AND (substring(\u00272022-08-31\u0027, 1, 7)))) tbl_mock_263 ON ((tbl_mock_261.mock_176 \u003d tbl_mock_263.mock_176) AND (tbl_mock_261.mock_151 \u003d tbl_mock_263.mock_149)) AND ((substring(tbl_mock_253.mock_251, 1, 7)) \u003d tbl_mock_263.mock_222) LEFT OUTER JOIN (SELECT tbl_mock_221.mock_176, tbl_mock_221.mock_149, tbl_mock_221.mock_223, tbl_mock_221.mock_164, tbl_mock_221.mock_222\nFROM db_mock_000.tbl_mock_221\nWHERE (tbl_mock_221.mock_176 \u003d 1) AND (tbl_mock_221.mock_222 BETWEEN (substring(\u00272022-08-01\u0027, 1, 7)) AND (substring(\u00272022-08-31\u0027, 1, 7)))) tbl_mock_264 ON ((tbl_mock_261.mock_176 \u003d tbl_mock_263.mock_176) AND (tbl_mock_261.mock_182 \u003d tbl_mock_263.mock_149)) AND ((substring(tbl_mock_253.mock_251, 1, 7)) \u003d tbl_mock_263.mock_222) LEFT OUTER JOIN (SELECT tbl_mock_221.mock_176, tbl_mock_221.mock_149, tbl_mock_221.mock_223, tbl_mock_221.mock_164, tbl_mock_221.mock_222\nFROM db_mock_000.tbl_mock_221\nWHERE (tbl_mock_221.mock_176 \u003d 1) AND (tbl_mock_221.mock_222 BETWEEN (substring(\u00272022-08-01\u0027, 1, 7)) AND (substring(\u00272022-08-31\u0027, 1, 7)))) tbl_mock_265 ON ((tbl_mock_261.mock_176 \u003d tbl_mock_265.mock_176) AND (tbl_mock_261.mock_010 \u003d tbl_mock_265.mock_149)) AND ((substring(tbl_mock_253.mock_251, 1, 7)) \u003d tbl_mock_265.mock_222) LEFT OUTER JOIN (SELECT tbl_mock_221.mock_176, tbl_mock_221.mock_149, tbl_mock_221.mock_223, tbl_mock_221.mock_164, tbl_mock_221.mock_222\nFROM db_mock_000.tbl_mock_221\nWHERE ((tbl_mock_221.mock_176 \u003d 1) AND (tbl_mock_221.mock_222 BETWEEN (substring(\u00272022-08-01\u0027, 1, 7)) AND (substring(\u00272022-08-31\u0027, 1, 7)))) AND (tbl_mock_221.mock_149 \u003d \u0027USD\u0027)) tbl_mock_266 ON (tbl_mock_261.mock_176 \u003d tbl_mock_263.mock_176) AND ((substring(tbl_mock_253.mock_251, 1, 7)) \u003d tbl_mock_266.mock_222)\nGROUP BY tbl_mock_261.mock_205) tbl_mock_236 , LATERAL unnest(split(tbl_mock_236.mock_205, \u0027,\u0027)) ) tbl_mock_236","table_meta":{"db_mock_000.tbl_mock_001":"CREATE TABLE db_mock_000.tbl_mock_001 (\nmock_012 bigint(20) NOT NULL ,\nmock_047 bigint(20) NOT NULL ,\nid bigint(20) NOT NULL ,\nmock_049 date ,\nmock_072 varchar(300) ,\nmock_023 varchar(300) ,\nmock_073 varchar(300) ,\nmock_007 varchar(300) ,\nmock_044 decimal64(16, 6) ,\nmock_056 decimal64(16, 6) ,\nmock_057 bigint(20) ,\nmock_068 decimal64(16, 6) ,\nmock_069 bigint(20) ,\nmock_043 decimal64(16, 6) ,\nmock_054 decimal64(16, 6) ,\nmock_055 bigint(20) ,\nmock_066 decimal64(16, 6) ,\nmock_067 bigint(20) ,\nmock_041 decimal64(16, 6) ,\nmock_116 decimal64(16, 6) ,\nmock_126 decimal64(16, 6) ,\nmock_052 decimal64(16, 6) ,\nmock_053 bigint(20) ,\nmock_064 decimal64(16, 6) ,\nmock_065 bigint(20) ,\nmock_040 decimal64(16, 6) ,\nmock_050 decimal64(16, 6) ,\nmock_051 bigint(20) ,\nmock_062 decimal64(16, 6) ,\nmock_063 bigint(20) ,\nmock_026 decimal64(16, 6) ,\nmock_101 decimal64(16, 6) ,\nmock_136 decimal64(16, 6) ,\nmock_135 decimal64(16, 6) ,\nmock_033 decimal64(16, 6) ,\nmock_032 decimal64(16, 6) ,\nmock_059 decimal64(16, 6) ,\nmock_058 decimal64(16, 6) ,\nmock_003 decimal64(16, 6) ,\nmock_011 decimal64(16, 6) ,\nmock_081 decimal64(16, 6) ,\nmock_124 decimal64(16, 6) ,\nmock_021 decimal64(16, 6) ,\nmock_022 decimal64(16, 6) ,\nmock_114 decimal64(16, 6) ,\nmock_123 decimal64(16, 6) ,\nmock_086 decimal64(16, 6) ,\nmock_119 decimal64(16, 6) ,\nmock_084 decimal64(16, 6) ,\nmock_102 decimal64(16, 6) ,\nmock_071 decimal64(16, 6) ,\nmock_029 decimal64(16, 6) ,\nmock_074 decimal64(16, 6) ,\nmock_042 decimal64(16, 6) ,\nmock_038 decimal64(16, 6) ,\nmock_039 bigint(20) ,\nmock_031 decimal64(16, 6) ,\nmock_046 decimal64(16, 6) ,\nmock_045 decimal64(16, 6) ,\nmock_115 decimal64(16, 6) ,\nmock_105 decimal64(16, 6) ,\nmock_112 decimal64(16, 6) ,\nmock_127 decimal64(16, 6) ,\nmock_095 decimal64(16, 6) ,\nmock_104 decimal64(16, 6) ,\nmock_098 decimal64(16, 6) ,\nmock_109 decimal64(16, 6) ,\nmock_120 decimal64(16, 6) ,\nmock_094 decimal64(16, 6) ,\nmock_097 decimal64(16, 6) ,\nmock_108 decimal64(16, 6) ,\nmock_080 decimal64(16, 6) ,\nmock_096 decimal64(16, 6) ,\nmock_103 decimal64(16, 6) ,\nmock_082 decimal64(16, 6) ,\nmock_129 decimal64(16, 6) ,\nmock_137 decimal64(16, 6) ,\nmock_138 decimal64(16, 6) ,\nmock_083 decimal64(16, 6) ,\nmock_118 decimal64(16, 6) ,\nmock_099 decimal64(16, 6) ,\nmock_128 decimal64(16, 6) ,\nmock_110 decimal64(16, 6) ,\nmock_090 decimal64(16, 6) ,\nmock_092 decimal64(16, 6) ,\nmock_113 decimal64(16, 6) ,\nmock_060 decimal64(16, 6) ,\nmock_075 decimal64(16, 6) ,\nmock_048 decimal64(16, 6) ,\nmock_006 decimal64(16, 6) ,\nmock_076 decimal64(16, 6) ,\nmock_077 decimal64(16, 6) ,\nmock_005 decimal64(16, 6) ,\nmock_089 decimal64(16, 6) ,\nmock_121 decimal64(16, 6) ,\nmock_111 decimal64(16, 6) ,\nmock_144 decimal64(16, 6) ,\nmock_145 decimal64(16, 6) ,\nmock_146 decimal64(16, 6) ,\nmock_147 decimal64(16, 6) ,\nmock_142 decimal64(16, 6) ,\nmock_143 decimal64(16, 6) ,\nmock_087 decimal64(16, 6) ,\nmock_140 decimal64(16, 6) ,\nmock_130 decimal64(16, 6) ,\nmock_141 decimal64(16, 6) ,\nmock_131 decimal64(16, 6) ,\nmock_070 decimal64(16, 6) ,\nmock_125 decimal64(16, 6) ,\nmock_061 decimal64(16, 6) ,\nmock_122 decimal64(16, 6) ,\nmock_107 decimal64(16, 6) ,\nmock_132 decimal64(16, 6) ,\nmock_133 decimal64(16, 6) ,\nmock_093 decimal64(16, 6) ,\nmock_085 decimal64(16, 6) ,\nmock_091 decimal64(16, 6) ,\nmock_079 decimal64(16, 6) ,\nmock_078 decimal64(16, 6) ,\nmock_106 decimal64(16, 6) ,\nmock_004 decimal64(16, 6) ,\nmock_030 decimal64(16, 6) ,\nmock_037 decimal64(16, 6) ,\nmock_134 decimal64(16, 6) ,\nmock_008 decimal64(16, 6) ,\nmock_009 decimal64(16, 6) ,\nmock_010 varchar(300) ,\nmock_139 varchar(1000) ,\nmock_036 varchar(1500) ,\nmock_100 decimal64(16, 6) ,\nmock_025 decimal64(16, 6) ,\nmock_117 decimal64(16, 6) ,\nmock_035 datetime ,\nmock_034 datetime ,\nmock_019 decimal64(16, 6) ,\nmock_018 varchar(65533) ,\nmock_015 decimal64(16, 6) ,\nmock_014 varchar(65533) ,\nmock_017 decimal64(16, 6) ,\nmock_016 varchar(65533) ,\nmock_020 bigint(20) ,\nmock_013 varchar(50) ,\nmock_088 decimal64(16, 6) ,\nmock_027 bigint(20) ,\nmock_028 bigint(20) ,\nmock_024 decimal64(16, 6) ,\nmock_002 varchar(65535) \n) ENGINE\u003d OLAP\nPRIMARY KEY(mock_012, mock_047, id)\nPARTITION BY RANGE(mock_047)\n(PARTITION p1 VALUES [(\"1\"), (\"2\")),\nPARTITION p2 VALUES [(\"2\"), (\"3\")),\nPARTITION p3 VALUES [(\"3\"), (\"4\")),\nPARTITION p4 VALUES [(\"4\"), (\"5\")),\nPARTITION p5 VALUES [(\"5\"), (\"6\")),\nPARTITION p6 VALUES [(\"6\"), (\"7\")),\nPARTITION p7 VALUES [(\"7\"), (\"8\")),\nPARTITION p8 VALUES [(\"8\"), (\"9\")),\nPARTITION p9 VALUES [(\"9\"), (\"10\")))\nDISTRIBUTED BY HASH(mock_012, mock_047, id) BUCKETS 10 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_148":"CREATE TABLE db_mock_000.tbl_mock_148 (\nmock_176 int(11) ,\nmock_171 int(11) ,\nmock_151 char(15) ,\nmock_160 int(11) ,\nmock_167 int(11) ,\nmock_163 varchar(150) ,\nmock_168 varchar(150) ,\nmock_072 varchar(90) ,\nmock_161 varchar(150) ,\nmock_170 smallint(6) ,\nmock_169 int(11) ,\nmock_035 datetime ,\nmock_034 datetime ,\nmock_173 varchar(996) ,\nmock_165 char(6) ,\nmock_150 varchar(72) ,\nmock_149 char(12) ,\nmock_162 varchar(64) ,\nmock_172 varchar(765) ,\nmock_156 char(48) ,\nmock_157 char(48) ,\nmock_175 varchar(60) ,\nmock_174 varchar(60) ,\nmock_166 varchar(60) ,\nmock_158 int(11) ,\nmock_159 int(11) ,\nmock_152 varchar(200) ,\nmock_153 varchar(500) ,\nmock_164 decimal64(10, 4) DEFAULT \"0.0000\" ,\nmock_155 int(11) ,\nmock_154 int(11) ,\nmock_012 bigint(20) DEFAULT \"0\" \n) ENGINE\u003d OLAP\nUNIQUE KEY(mock_176, mock_171, mock_151)\nDISTRIBUTED BY HASH(mock_176, mock_171) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_177":"CREATE TABLE db_mock_000.tbl_mock_177 (\nmock_176 int(11) ,\nmock_171 int(11) ,\nmock_073 varchar(150) ,\nmock_202 varchar(60) ,\nmock_007 varchar(60) ,\nmock_203 int(11) ,\nmock_179 int(11) ,\nmock_183 int(11) ,\nmock_210 bigint(20) ,\nmock_181 varchar(1500) ,\nmock_198 varchar(150) ,\nmock_197 varchar(1500) ,\nmock_036 varchar(1500) ,\nmock_194 varchar(90) ,\nmock_195 varchar(30) ,\nmock_204 decimal64(18, 6) ,\nmock_008 decimal64(18, 6) ,\nmock_186 varchar(900) ,\nmock_191 varchar(30) ,\nmock_220 int(11) ,\nmock_139 varchar(900) ,\nmock_184 varchar(150) ,\nmock_200 varchar(120) ,\nmock_196 varchar(90) ,\nmock_185 varchar(150) ,\nmock_035 datetime ,\nmock_208 varchar(900) ,\nmock_209 int(11) ,\nmock_207 varchar(150) ,\nmock_212 varchar(150) ,\nmock_199 varchar(300) ,\nmock_211 varchar(900) ,\nmock_213 int(11) ,\nmock_215 varchar(1000) ,\nmock_180 varchar(100) ,\nmock_192 varchar(90) ,\nmock_201 int(11) ,\nmock_193 varchar(90) ,\nmock_187 int(11) ,\nmock_205 varchar(200) ,\nmock_216 decimal64(16, 6) ,\nmock_217 varchar(100) ,\nmock_190 int(11) ,\nmock_188 int(11) ,\nmock_189 int(11) ,\nmock_182 varchar(50) ,\nmock_009 decimal64(18, 6) ,\nmock_010 varchar(50) ,\nmock_012 bigint(20) DEFAULT \"0\" ,\nmock_178 varchar(65535) ,\nmock_214 int(11) ,\nmock_218 varchar(65535) ,\nmock_219 varchar(65535) ,\nmock_206 int(11) DEFAULT \"0\" \n) ENGINE\u003d OLAP\nUNIQUE KEY(mock_176, mock_171, mock_073)\nDISTRIBUTED BY HASH(mock_176, mock_171, mock_073) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_221":"CREATE TABLE db_mock_000.tbl_mock_221 (\nid bigint(20) NOT NULL ,\nmock_176 int(11) NOT NULL ,\nmock_149 varchar(65533) ,\nmock_223 varchar(65533) ,\nmock_163 varchar(65533) ,\nmock_164 decimal128(18, 10) DEFAULT \"0.0000\" ,\nmock_225 decimal128(19, 6) ,\nmock_228 int(11) DEFAULT \"99\" ,\nmock_230 int(11) DEFAULT \"0\" ,\nmock_224 int(11) DEFAULT \"0\" ,\nmock_222 varchar(65533) ,\nmock_035 datetime ,\nmock_034 datetime ,\nmock_229 varchar(65533) ,\nmock_227 decimal64(18, 10) DEFAULT \"0.0000000000\" ,\nmock_226 decimal64(18, 10) DEFAULT \"0.0000000000\" ,\nmock_012 bigint(20) DEFAULT \"0\" ,\nmock_231 varchar(120) DEFAULT \"\" \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);"},"table_row_count":{},"column_statistics":{},"session_variables":"{\"partial_update_mode\":\"auto\",\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"enable_hive_metadata_cache_with_insert\":false,\"cbo_cte_reuse_rate_v2\":1.15,\"character_set_results\":\"utf8\",\"enable_count_star_optimization\":true,\"query_excluding_mv_names\":\"\",\"enable_rewrite_simple_agg_to_meta_scan\":false,\"enable_adaptive_sink_dop\":true,\"consistent_hash_virtual_number\":32,\"enable_profile\":false,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"disable_function_fold_constants\":false,\"select_ratio_threshold\":0.15,\"query_delivery_timeout\":300,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"profile_limit_fold\":true,\"spill_operator_max_bytes\":1048576000,\"cbo_max_reorder_node_use_dp\":10,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"query_cache_agg_cardinality_limit\":5000000,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"materialized_view_rewrite_mode\":\"DEFAULT\",\"enable_simplify_case_when\":true,\"runtime_join_filter_push_down_limit\":1024000,\"big_query_log_cpu_second_threshold\":480,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":32,\"prefer_cte_rewrite\":false,\"hdfs_backend_selector_scan_range_shuffle\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"hive_partition_stats_sample_size\":3000,\"enable_mv_planner\":false,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"spill_encode_level\":7,\"enable_query_dump\":false,\"global_runtime_filter_build_max_size\":67108864,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"enable_mv_optimizer_trace_log\":false,\"connector_io_tasks_per_scan_operator\":16,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_exchange_pass_through\":true,\"runtime_profile_report_interval\":10,\"query_cache_entry_max_bytes\":4194304,\"enable_exchange_perf\":false,\"workgroup_id\":0,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"use_page_cache\":true,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"spill_mode\":\"auto\",\"enable_query_debug_trace\":false,\"enable_show_all_variables\":false,\"full_sort_max_buffered_bytes\":16777216,\"wait_timeout\":28800,\"transmission_encode_level\":7,\"query_including_mv_names\":\"\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"enable_load_profile\":false,\"enable_plan_validation\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"scan_use_query_mem_ratio\":0.3,\"new_planner_optimize_timeout\":3000,\"enable_outer_join_reorder\":true,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"cbo_enable_greedy_join_reorder\":true,\"range_pruner_max_predicate\":100,\"enable_rbo_table_prune\":false,\"spillable_operator_mask\":-1,\"rpc_http_min_size\":2147482624,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":4,\"enable_cbo_table_prune\":false,\"enable_parallel_merge\":true,\"nested_mv_rewrite_max_level\":3,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"spill_revocable_max_bytes\":0,\"hash_join_push_down_right_table\":true,\"pipeline_sink_dop\":0,\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"cbo_prune_subfield\":true,\"full_sort_max_buffered_rows\":1024000,\"query_timeout\":300,\"connector_io_tasks_slow_io_latency_ms\":50,\"cbo_max_reorder_node\":50,\"enable_distinct_column_bucketization\":false,\"enable_big_query_log\":true,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"enable_sync_materialized_view_rewrite\":true,\"prefer_compute_node\":false,\"enable_strict_type\":false,\"group_concat_max_len\":65535,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_scan_block_cache\":false,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"spill_operator_min_bytes\":52428800,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"enable_spill\":false,\"pipeline_dop\":0,\"single_node_exec_plan\":false,\"full_sort_late_materialization_v2\":true,\"join_implementation_mode_v2\":\"auto\",\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"hdfs_backend_selector_hash_algorithm\":\"consistent\",\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"default_table_compression\":\"lz4_frame\",\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.8,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_predicate_reorder\":false,\"enable_query_cache\":false,\"max_allowed_packet\":33554432,\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"allow_default_partition\":false}","be_number":3,"be_core_stat":{"numOfHardwareCoresPerBe":"{\"32068493\":16,\"32068492\":16,\"32068494\":16}","cachedAvgNumOfHardwareCores":16},"exception":[]}